*** Paper: 			Does The World Trade Organization Enable Biosecurity and Trade for Importers and Exporters?
*** Authors: Linda Fernandez and Monica Das
*** Date:    		November 9, 2023
*** Last updated:   February 21, 2024
*** Description:	STATA codes for Tables 1 and 2 in the paper

*******************************************************
********** Table 1                                 ****
*********                                        ****
*******************************************************
///Download STATA file "wd.dta" from the Harvard Dataverse  
///Change directory to appropriate folder
//import STATA dataset "wd.dta" 

use "wd.dta", clear

asdoc sum AgrExport AE_GDP agrva TACommlag TAduration lnTAvalue Manu_sh ETI lnRGDP , stat(N median mean sd min max) save(Table 1) d dec(2) replace

*******************************************************
********** Table 2                                 ****
*********                                        ****
*******************************************************
///Download STATA file "wd.dta" from the Harvard Dataverse  
///Change directory to appropriate folder
//import STATA dataset "wd.dta" 
use "wd.dta", clear

gen Sum_Tot = 165 + 57 + 347 + 140
gen Sh_region = (Sum_Int/ Sum_Assist)*100
gen Sh_tot = (Sum_Int/ Sum_Tot )*100

collapse Sum_Assist Sum_Int Sum_Tot Sh_region Sh_tot, by(regioncode)

export excel regioncode Sum_Assist Sum_Int Sum_Tot Sh_region Sh_tot using "Table 2.xlsx", firstrow(variables) replace 
